/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : localhost:3306
 Source Schema         : templatestatistics

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 03/11/2021 22:01:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` int DEFAULT '0' COMMENT '逻辑删除',
  `version` int DEFAULT '1' COMMENT '乐观锁',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of department
-- ----------------------------
BEGIN;
INSERT INTO `department` VALUES (1, '一组', '2021-10-31 09:54:44', '2021-10-31 09:54:48', 0, 1);
INSERT INTO `department` VALUES (2, '二组', '2021-10-31 09:54:51', '2021-10-31 09:54:53', 0, 1);
INSERT INTO `department` VALUES (3, '三组', '2021-10-31 09:54:57', '2021-10-31 09:55:00', 0, 1);
INSERT INTO `department` VALUES (4, '四组', '2021-10-31 09:55:03', '2021-10-31 09:55:06', 0, 1);
INSERT INTO `department` VALUES (5, '五组', '2021-10-31 09:55:09', '2021-10-31 09:55:12', 0, 1);
INSERT INTO `department` VALUES (6, '测试', '2021-11-02 01:25:02', '2021-11-02 01:25:02', 0, 1);
INSERT INTO `department` VALUES (7, '页面测试12', '2021-11-02 01:26:01', '2021-11-02 11:49:41', 0, 1);
INSERT INTO `department` VALUES (8, '页面测试2', '2021-11-02 01:26:12', '2021-11-02 01:26:12', 1, 1);
INSERT INTO `department` VALUES (9, '继续测试', '2021-11-02 11:46:39', '2021-11-02 11:46:39', 0, 1);
INSERT INTO `department` VALUES (10, '接着测试', '2021-11-02 11:46:45', '2021-11-02 11:46:45', 0, 1);
INSERT INTO `department` VALUES (11, '压力测试1', '2021-11-02 11:46:53', '2021-11-02 18:59:48', 0, 1);
INSERT INTO `department` VALUES (12, '还要测试', '2021-11-02 11:47:01', '2021-11-02 11:47:01', 1, 1);
INSERT INTO `department` VALUES (13, '页面测试2', '2021-11-02 11:48:58', '2021-11-02 11:49:06', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for staff
-- ----------------------------
DROP TABLE IF EXISTS `staff`;
CREATE TABLE `staff` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工姓名',
  `departmentid` int NOT NULL COMMENT '部门Id',
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所处位置',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `deleted` int DEFAULT '0' COMMENT '逻辑删除',
  `version` int DEFAULT '1' COMMENT '乐观锁',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of staff
-- ----------------------------
BEGIN;
INSERT INTO `staff` VALUES (1, '张三', 1, '安徽', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (2, '李四', 2, '河南', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (3, '王二麻子', 3, '江苏', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (4, '丁某', 4, '上海', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (5, '叶某', 5, '福建', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (6, '何某', 1, '北京', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (7, '周某', 1, '内蒙古', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (8, '苏某', 2, '甘肃', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (9, '阮某', 3, '青海', '2021-10-31 01:53:46', '2021-10-31 01:53:46', 0, 1);
INSERT INTO `staff` VALUES (10, '美某', 3, '湖南', '2021-11-02 19:09:37', '2021-11-02 19:22:38', 0, 1);
INSERT INTO `staff` VALUES (11, '李某某', 6, '西藏', '2021-11-02 19:10:09', '2021-11-02 19:21:56', 0, 1);
INSERT INTO `staff` VALUES (12, '韩某某', 5, '贵州', '2021-11-02 19:13:16', '2021-11-02 19:13:16', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for temprecord
-- ----------------------------
DROP TABLE IF EXISTS `temprecord`;
CREATE TABLE `temprecord` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `staffname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '员工姓名',
  `departmentid` int NOT NULL COMMENT '部门Id',
  `temperature` decimal(3,1) NOT NULL COMMENT '体温',
  `date` date NOT NULL COMMENT '测量日期',
  `day` int DEFAULT NULL COMMENT '上午',
  `night` int DEFAULT NULL COMMENT '下午',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `version` int DEFAULT '1' COMMENT '乐观锁',
  `deleted` int DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of temprecord
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键Id',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
  `password` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `departmentid` int DEFAULT '1' COMMENT '所属部门Id',
  `version` int DEFAULT '1' COMMENT '乐观锁',
  `deleted` int DEFAULT '0' COMMENT '逻辑删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '一组用户', '123456', 1, 1, 0, '2021-10-31 01:50:10', '2021-11-02 23:41:46');
INSERT INTO `user` VALUES (2, '二组用户', '123456', 2, 1, 0, '2021-10-31 01:50:10', '2021-11-02 23:41:54');
INSERT INTO `user` VALUES (3, '三组用户', '123456', 3, 1, 0, '2021-10-31 01:50:10', '2021-11-03 21:58:39');
INSERT INTO `user` VALUES (4, '四组用户', '123456', 1, 1, 0, '2021-10-31 01:50:10', '2021-11-02 23:42:07');
INSERT INTO `user` VALUES (5, '五组用户', '123456', 1, 1, 0, '2021-10-31 01:50:10', '2021-11-02 23:42:14');
INSERT INTO `user` VALUES (6, 'Failed', 'Failed', 1, 4, 0, '2021-10-31 01:50:10', '2021-10-31 21:17:42');
INSERT INTO `user` VALUES (9, 'test', 'test', 1, 1, 1, '2021-10-31 21:38:26', '2021-10-31 21:38:26');
INSERT INTO `user` VALUES (10, '用户测试1', '12345', 4, 1, 0, '2021-11-02 17:10:12', '2021-11-02 17:10:12');
INSERT INTO `user` VALUES (11, '用户测试2', '12376', 10, 1, 0, '2021-11-02 17:39:30', '2021-11-02 17:39:30');
INSERT INTO `user` VALUES (12, '用户接着测试1', 'admin', 3, 1, 0, '2021-11-02 17:40:14', '2021-11-02 17:40:14');
INSERT INTO `user` VALUES (13, '用户压力测试12', 'admin23', 2, 1, 0, '2021-11-02 17:40:33', '2021-11-03 21:02:08');
INSERT INTO `user` VALUES (14, '用户测试2', '176233', 6, 1, 0, '2021-11-02 17:40:57', '2021-11-02 17:41:08');
INSERT INTO `user` VALUES (15, '一组用户测试', '12333', 9, 1, 1, '2021-11-02 17:41:53', '2021-11-02 17:41:53');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
